﻿CREATE TABLE [dbo].[Foods] (
    [FoodID]          INT           IDENTITY (1, 1) NOT NULL,
    [FoodName]        NVARCHAR (50) NOT NULL,
    [FoodBrandID]     INT           NULL,
    [RecipeID]        INT           NULL,
    [UserID]          INT           NULL,
    [DateTimeAdded]   DATETIME      NOT NULL,
    [DateTimeUpdated] DATETIME      NOT NULL,
    [HealthRatingID]  INT           NULL
);

